USE [genshi]
GO

/****** Object:  Table [dbo].[Relics]    Script Date: 2022/5/3 20:26:23 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Relics](
	[id] [smallint] NOT NULL,
	[position] [nvarchar](7) NOT NULL,
	[setName] [nvarchar](7) NOT NULL,
	[detailName] [nvarchar](9) NOT NULL,
	[mainTagname] [nvarchar](19) NOT NULL,
	[mainTagvalue] [real] NOT NULL,
	[Tagname_1] [nvarchar](19) NULL,
	[value_1] [real] NULL,
	[Tagname_2] [nvarchar](19) NULL,
	[value_2] [real] NULL,
	[Tagname_3] [nvarchar](19) NULL,
	[value_3] [real] NULL,
	[Tagname_4] [nvarchar](19) NULL,
	[value_4] [real] NULL,
	[grade] [smallint] NOT NULL,
	[equipped] [nvarchar](8) NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

